package models;

import java.util.HashSet;
import java.util.Set;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;

import org.hibernate.annotations.ForeignKey;

import play.db.jpa.Model;

@Entity
@Table(name = "member")
public class Member extends Model {
	
	@Column(name="lec_num",length=50)
	public String lecnum; 
	
	@Column(name="met_id",length=50)
	public String metid; 
	
	@Column(name="gra_id",length=50)
	public String graid; 
	
	@Column(name="mem_num",length=50)
	public String memnum; 
	
	@Column(name="mem_pass",length=32)
	public String mempass; 
	
	@Column(name="mem_time",length=50)
	public String memtime;
	
	@Column(name="mem_name",length=50)
	public String memname;
	
	@Column(name="mem_pho",length=20)
	public String mempho;
	
	@Column(name="mem_addr",length=150)
	public String memaddr;
	
	@Column(name="mem_addr2",length=150)
	public String memaddr2; 
	
	@Column(name="mem_addr3",length=150)
	public String memaddr3; 
	
	@Column(name="mem_addr4",length=150)
	public String memaddr4; 
	
	@Column(name="mem_inte",length=250)
	public String meminte; 
	
	@Column(name="mem_tel",length=20)
	public String memtel; 
	
	@Column(name="mem_poca",length=10)
	public String mempoca; 
	
	@Column(name="mem_jifen")
	public Integer memjifen; 
	
	@Column(name="mem_states")
	public Integer memstate; 
	
	@Column(name="mem_email",length=100)
	public String mememail; 
	
	@Column(name="mem_ide",length=22)
	public String menide; 
	
	@Column(name="school",length=50)
	public String school;
	
	@Column(name="department",length=50)
	public String department; //院系
	
	@Column(name="major",length=50)
	public String major; //专业
	
	@Column(name="sex")
	public Integer sex; //专业
	
	@Column(name="booknum")
	public Integer booknum; //捐书数量
	
}
